<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>Upgrade iRedMail from 0.7.1 to 0.7.2</title>
        <link rel="stylesheet" type="text/css" href="./css/markdown.css" />
    </head>
    <body>

    <div id="navigation">
    <a href="https://www.iredmail.org" target="_blank">
        <img alt="iRedMail web site"
             src="./images/logo-iredmail.png"
             style="vertical-align: middle; height: 30px;"
             />&nbsp;
        <span>iRedMail</span>
    </a>
    &nbsp;&nbsp;//&nbsp;&nbsp;<a href="./index.html">Document Index</a></div><h1 id="upgrade-iredmail-from-071-to-072">Upgrade iRedMail from 0.7.1 to 0.7.2</h1>
<div class="admonition attention">
<p class="admonition-title">Attention</p>
<p>Check out the lightweight on-premises email archiving software developed by iRedMail team: <a href="https://spiderd.io/">Spider Email Archiver</a>.</p>
</div>
<div class="toc">
<ul>
<li><a href="#upgrade-iredmail-from-071-to-072">Upgrade iRedMail from 0.7.1 to 0.7.2</a><ul>
<li><a href="#general-all-backends-should-apply-these-upgrade-steps">General (All backends should apply these upgrade steps)</a><ul>
<li><a href="#update-fail2ban-filter">Update Fail2ban filter</a></li>
</ul>
</li>
<li><a href="#mysql-backend-special">MySQL backend special</a><ul>
<li><a href="#add-alias-domain-support-in-postfix">Add alias domain support in postfix</a></li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
<div class="admonition note">
<p class="admonition-title">Remote Upgrade Assistance</p>
<p>Check out our <a href="https://www.iredmail.org/support.html">remote upgrade support</a> if you need assistance.</p>
</div>
<h2 id="general-all-backends-should-apply-these-upgrade-steps">General (All backends should apply these upgrade steps)</h2>
<h3 id="update-fail2ban-filter">Update Fail2ban filter</h3>
<p>Note: This step is applicable to Linux. We don't have Fail2ban running on FreeBSD.</p>
<ul>
<li>Edit <code>/etc/fail2ban/filter.d/postfix.iredmail.conf</code>, change line <code>failregex =</code>:</li>
</ul>
<pre><code># Part of file: /etc/fail2ban/filter.d/postfix.iredmail.conf

# Original line:
#failregex = \[&lt;HOST&gt;\]: SASL PLAIN authentication failed

# Modified
failregex = \[&lt;HOST&gt;\]: SASL (PLAIN|LOGIN) authentication failed
</code></pre>
<h2 id="mysql-backend-special">MySQL backend special</h2>
<h3 id="add-alias-domain-support-in-postfix">Add alias domain support in postfix</h3>
<p>Update MySQL query in postfix setting <code>virtual_mailbox_domains</code> to query alias
domains.</p>
<pre><code># Part of file: /etc/postfix/mysql/virtual_mailbox_domains.cf

# Original line:
#query       = SELECT domain FROM domain WHERE domain='%s' AND backupmx=0 AND active=1

# Modified:
query       = SELECT domain FROM domain WHERE domain='%s' AND backupmx=0 AND active=1 UNION SELECT alias_domain.alias_domain FROM alias_domain,domain WHERE alias_domain.alias_domain='%s' AND alias_domain.active=1 AND alias_domain.target_domain=domain.domain AND domain.active=1 AND domain.backupmx=0
</code></pre><div class="footer">
    <p style="text-align: center; color: grey;">All documents are available in <a href="https://github.com/iredmail/docs/">GitHub repository</a>, and published under <a href="http://creativecommons.org/licenses/by-nd/3.0/us/" target="_blank">Creative Commons</a> license. You can <a href="https://github.com/iredmail/docs/archive/master.zip">download the latest version</a> for offline reading. If you found something wrong, please do <a href="https://www.iredmail.org/contact.html">contact us</a> to fix it.</p>
</div></body></html>